[ROOT] dt FactResellerSale < WHERE DimResellerId EQ '22' >
35 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO43874_1 | 190B-4F56-9E | PO12122162917 | 100 | 283 | 328 | 22 | 3 | 2021-05-31 | 419.46 | 10.49 | 2021-05-19 | 1 | 413.15 | 1 | 419.46 | 1 | SO43874 | 2021-05-26 | 33.56 | 413.15 | 419.46 |
SO44519_1 | EEF0-4291-9B | PO12122152587 | 100 | 283 | 313 | 22 | 3 | 2021-08-31 | 2146.96 | 53.67 | 2021-08-19 | 1 | 2171.29 | 1 | 2146.96 | 1 | SO44519 | 2021-08-26 | 171.76 | 2171.29 | 2146.96 |
SO46989_1 | 32DF-41DF-BF | PO12122190140 | 100 | 283 | 242 | 22 | 3 | 2022-05-31 | 2342.45 | 58.56 | 2022-05-19 | 3 | 722.26 | 1 | 2342.45 | 1 | SO46989 | 2022-05-26 | 187.40 | 2166.77 | 780.82 |
SO51807_1 | D0BE-4C14-81 | PO12122119705 | 100 | 281 | 255 | 22 | 3 | 2023-05-31 | 202.33 | 5.06 | 2023-05-19 | 1 | 204.63 | 1 | 202.33 | 1 | SO51807 | 2023-05-26 | 16.19 | 204.63 | 202.33 |
SO51807_2 | D0BE-4C14-81 | PO12122119705 | 100 | 281 | 520 | 22 | 3 | 2023-05-31 | 31.58 | 0.79 | 2023-05-19 | 1 | 23.37 | 1 | 31.58 | 2 | SO51807 | 2023-05-26 | 2.53 | 23.37 | 31.58 |
SO51807_3 | D0BE-4C14-81 | PO12122119705 | 100 | 281 | 243 | 22 | 3 | 2023-05-31 | 858.90 | 21.47 | 2023-05-19 | 1 | 868.63 | 1 | 858.90 | 3 | SO51807 | 2023-05-26 | 68.71 | 868.63 | 858.90 |
SO51807_4 | D0BE-4C14-81 | PO12122119705 | 100 | 281 | 440 | 22 | 3 | 2023-05-31 | 1717.80 | 42.95 | 2023-05-19 | 2 | 868.63 | 1 | 1717.80 | 4 | SO51807 | 2023-05-26 | 137.42 | 1737.27 | 858.90 |
SO51807_5 | D0BE-4C14-81 | PO12122119705 | 100 | 281 | 240 | 22 | 3 | 2023-05-31 | 858.90 | 21.47 | 2023-05-19 | 1 | 868.63 | 1 | 858.90 | 5 | SO51807 | 2023-05-26 | 68.71 | 868.63 | 858.90 |
SO57113_1 | 160E-42A8-97 | PO12122117991 | 100 | 281 | 408 | 22 | 3 | 2023-08-31 | 144.32 | 3.61 | 2023-08-19 | 2 | 53.40 | 1 | 144.32 | 1 | SO57113 | 2023-08-26 | 11.55 | 106.80 | 72.16 |
SO57113_2 | 160E-42A8-97 | PO12122117991 | 100 | 281 | 372 | 22 | 3 | 2023-08-31 | 1466.01 | 36.65 | 2023-08-19 | 1 | 1554.95 | 1 | 1466.01 | 2 | SO57113 | 2023-08-26 | 117.28 | 1554.95 | 1466.01 |
SO57113_3 | 160E-42A8-97 | PO12122117991 | 100 | 281 | 434 | 22 | 3 | 2023-08-31 | 1427.59 | 35.69 | 2023-08-19 | 4 | 360.94 | 1 | 1427.59 | 3 | SO57113 | 2023-08-26 | 114.21 | 1443.77 | 356.90 |
SO57113_4 | 160E-42A8-97 | PO12122117991 | 100 | 281 | 436 | 22 | 3 | 2023-08-31 | 1427.59 | 35.69 | 2023-08-19 | 4 | 360.94 | 1 | 1427.59 | 4 | SO57113 | 2023-08-26 | 114.21 | 1443.77 | 356.90 |
SO48013_1 | 12C7-44E7-8D | PO12122129065 | 100 | 283 | 407 | 22 | 3 | 2022-08-31 | 262.41 | 6.56 | 2022-08-19 | 4 | 48.55 | 1 | 262.41 | 1 | SO48013 | 2022-08-26 | 20.99 | 194.18 | 65.60 |
SO48013_2 | 12C7-44E7-8D | PO12122129065 | 100 | 283 | 414 | 22 | 3 | 2022-08-31 | 149.03 | 3.73 | 2022-08-19 | 1 | 110.28 | 1 | 149.03 | 2 | SO48013 | 2022-08-26 | 11.92 | 110.28 | 149.03 |
SO48013_3 | 12C7-44E7-8D | PO12122129065 | 100 | 283 | 254 | 22 | 3 | 2022-08-31 | 735.75 | 18.39 | 2022-08-19 | 4 | 170.14 | 1 | 735.75 | 3 | SO48013 | 2022-08-26 | 58.86 | 680.57 | 183.94 |
SO48013_4 | 12C7-44E7-8D | PO12122129065 | 100 | 283 | 273 | 22 | 3 | 2022-08-31 | 202.33 | 5.06 | 2022-08-19 | 1 | 187.16 | 1 | 202.33 | 4 | SO48013 | 2022-08-26 | 16.19 | 187.16 | 202.33 |
SO48013_5 | 12C7-44E7-8D | PO12122129065 | 100 | 283 | 435 | 22 | 3 | 2022-08-31 | 324.45 | 8.11 | 2022-08-19 | 1 | 300.12 | 1 | 324.45 | 5 | SO48013 | 2022-08-26 | 25.96 | 300.12 | 324.45 |
SO48013_6 | 12C7-44E7-8D | PO12122129065 | 100 | 283 | 417 | 22 | 3 | 2022-08-31 | 324.45 | 8.11 | 2022-08-19 | 1 | 300.12 | 1 | 324.45 | 6 | SO48013 | 2022-08-26 | 25.96 | 300.12 | 324.45 |
SO49130_1 | 6D40-4F8C-85 | PO12122177177 | 100 | 281 | 379 | 22 | 3 | 2022-12-01 | 1308.94 | 32.72 | 2022-11-19 | 1 | 1320.68 | 1 | 1308.94 | 1 | SO49130 | 2022-11-26 | 104.72 | 1320.68 | 1308.94 |
SO49130_2 | 6D40-4F8C-85 | PO12122177177 | 100 | 281 | 216 | 22 | 3 | 2022-12-01 | 40.37 | 1.01 | 2022-11-19 | 2 | 13.88 | 1 | 40.37 | 2 | SO49130 | 2022-11-26 | 3.23 | 27.76 | 20.19 |
SO49130_3 | 6D40-4F8C-85 | PO12122177177 | 100 | 281 | 422 | 22 | 3 | 2022-12-01 | 67.54 | 1.69 | 2022-11-19 | 1 | 49.98 | 1 | 67.54 | 3 | SO49130 | 2022-11-26 | 5.40 | 49.98 | 67.54 |
SO50274_1 | E0C8-4640-8C | PO12122170752 | 100 | 281 | 265 | 22 | 3 | 2023-02-28 | 404.66 | 10.12 | 2023-02-16 | 2 | 187.16 | 1 | 404.66 | 1 | SO50274 | 2023-02-23 | 32.37 | 374.31 | 202.33 |
SO50274_2 | E0C8-4640-8C | PO12122170752 | 100 | 281 | 263 | 22 | 3 | 2023-02-28 | 202.33 | 5.06 | 2023-02-16 | 1 | 187.16 | 1 | 202.33 | 2 | SO50274 | 2023-02-23 | 16.19 | 187.16 | 202.33 |
SO50274_3 | E0C8-4640-8C | PO12122170752 | 100 | 281 | 273 | 22 | 3 | 2023-02-28 | 202.33 | 5.06 | 2023-02-16 | 1 | 187.16 | 1 | 202.33 | 3 | SO50274 | 2023-02-23 | 16.19 | 187.16 | 202.33 |
SO50274_4 | E0C8-4640-8C | PO12122170752 | 100 | 281 | 435 | 22 | 3 | 2023-02-28 | 324.45 | 8.11 | 2023-02-16 | 1 | 300.12 | 1 | 324.45 | 4 | SO50274 | 2023-02-23 | 25.96 | 300.12 | 324.45 |
SO50274_5 | E0C8-4640-8C | PO12122170752 | 100 | 281 | 254 | 22 | 3 | 2023-02-28 | 919.69 | 22.99 | 2023-02-16 | 5 | 170.14 | 1 | 919.69 | 5 | SO50274 | 2023-02-23 | 73.58 | 850.71 | 183.94 |
SO50274_6 | E0C8-4640-8C | PO12122170752 | 100 | 281 | 407 | 22 | 3 | 2023-02-28 | 131.20 | 3.28 | 2023-02-16 | 2 | 48.55 | 1 | 131.20 | 6 | SO50274 | 2023-02-23 | 10.50 | 97.09 | 65.60 |
SO63162_1 | E3D1-4029-85 | PO12122191571 | 100 | 281 | 545 | 22 | 3 | 2023-12-01 | 24.29 | 0.61 | 2023-11-19 | 1 | 17.98 | 1 | 24.29 | 1 | SO63162 | 2023-11-26 | 1.94 | 17.98 | 24.29 |
SO63162_2 | E3D1-4029-85 | PO12122191571 | 100 | 281 | 546 | 22 | 3 | 2023-12-01 | 74.51 | 1.86 | 2023-11-19 | 2 | 27.57 | 1 | 74.51 | 2 | SO63162 | 2023-11-26 | 5.96 | 55.14 | 37.25 |
SO63162_3 | E3D1-4029-85 | PO12122191571 | 100 | 281 | 547 | 22 | 3 | 2023-12-01 | 194.38 | 4.86 | 2023-11-19 | 4 | 35.96 | 1 | 194.38 | 3 | SO63162 | 2023-11-26 | 15.55 | 143.84 | 48.59 |
SO69495_1 | D387-4497-83 | PO12122175008 | 100 | 281 | 418 | 22 | 3 | 2024-02-29 | 713.80 | 17.84 | 2024-02-17 | 2 | 360.94 | 1 | 713.80 | 1 | SO69495 | 2024-02-24 | 57.10 | 721.89 | 356.90 |
SO69495_2 | D387-4497-83 | PO12122175008 | 100 | 281 | 436 | 22 | 3 | 2024-02-29 | 713.80 | 17.84 | 2024-02-17 | 2 | 360.94 | 1 | 713.80 | 2 | SO69495 | 2024-02-24 | 57.10 | 721.89 | 356.90 |
SO69495_3 | D387-4497-83 | PO12122175008 | 100 | 281 | 482 | 22 | 3 | 2024-02-29 | 10.79 | 0.27 | 2024-02-17 | 2 | 3.36 | 1 | 10.79 | 3 | SO69495 | 2024-02-24 | 0.86 | 6.72 | 5.39 |
SO69495_4 | D387-4497-83 | PO12122175008 | 100 | 281 | 287 | 22 | 3 | 2024-02-29 | 607.00 | 15.17 | 2024-02-17 | 3 | 204.63 | 1 | 607.00 | 4 | SO69495 | 2024-02-24 | 48.56 | 613.88 | 202.33 |
SO69495_5 | D387-4497-83 | PO12122175008 | 100 | 281 | 434 | 22 | 3 | 2024-02-29 | 356.90 | 8.92 | 2024-02-17 | 1 | 360.94 | 1 | 356.90 | 5 | SO69495 | 2024-02-24 | 28.55 | 360.94 | 356.90 |
Generated 2024-05-19 01:32:42.506 UTC